<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.2-20121118"/>
<title>SensorFramework: saxion.sensorframework.db.dao.DaoSensor Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td style="padding-left: 0.5em;">
   <div id="projectname">SensorFramework
   &#160;<span id="projectnumber">1</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.2-20121118 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Packages</span></a></li>
      <li class="current"><a href="annotated.html"><span>Classes</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>Class&#160;List</span></a></li>
      <li><a href="classes.html"><span>Class&#160;Index</span></a></li>
      <li><a href="inherits.html"><span>Class&#160;Hierarchy</span></a></li>
      <li><a href="functions.html"><span>Class&#160;Members</span></a></li>
    </ul>
  </div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&#160;</span>Pages</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="a00031.html">saxion</a></li><li class="navelem"><a class="el" href="a00032.html">sensorframework</a></li><li class="navelem"><a class="el" href="a00033.html">db</a></li><li class="navelem"><a class="el" href="a00036.html">dao</a></li><li class="navelem"><a class="el" href="a00003.html">DaoSensor</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="summary">
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#pac-static-attribs">Static Package Attributes</a> &#124;
<a href="#pri-methods">Private Member Functions</a> &#124;
<a href="#pri-attribs">Private Attributes</a> &#124;
<a href="a00054.html">List of all members</a>  </div>
  <div class="headertitle">
<div class="title">saxion.sensorframework.db.dao.DaoSensor Class Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>The Data Acces Object wich contains all data queries that will be executed by SqlConnect.  
 <a href="a00003.html#details">More...</a></p>
<div class="dynheader">
Collaboration diagram for saxion.sensorframework.db.dao.DaoSensor:</div>
<div class="dyncontent">
<div class="center"><img src="a00055.png" border="0" usemap="#saxion_8sensorframework_8db_8dao_8_dao_sensor_coll__map" alt="Collaboration graph"/></div>
<map name="saxion_8sensorframework_8db_8dao_8_dao_sensor_coll__map" id="saxion_8sensorframework_8db_8dao_8_dao_sensor_coll__map">
<area shape="rect" title=" ~logger" alt="" coords="108,81,116,89"/><area shape="rect" title=" ~logger" alt="" coords="108,145,116,153"/></map>
</div>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr class="memitem:ac88517169df3e3a6d6fbdda5abd781f1"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#ac88517169df3e3a6d6fbdda5abd781f1">DaoSensor</a> ()  throws SQLException, InstantiationException, 			IllegalAccessException, ClassNotFoundException </td></tr>
<tr class="separator:ac88517169df3e3a6d6fbdda5abd781f1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a05fec2fa9ee7f94a099c7ddc2e9fe98a"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a05fec2fa9ee7f94a099c7ddc2e9fe98a">addSensorData</a> (int sensorNr, List&lt; Object &gt; list)  throws SQLException </td></tr>
<tr class="memdesc:a05fec2fa9ee7f94a099c7ddc2e9fe98a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Add sensor data to the database.  <a href="#a05fec2fa9ee7f94a099c7ddc2e9fe98a"></a><br/></td></tr>
<tr class="separator:a05fec2fa9ee7f94a099c7ddc2e9fe98a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a132d764d3f79cd8c4245b6c91a4380cb"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a132d764d3f79cd8c4245b6c91a4380cb">addSensorAndDataTable</a> (<a class="el" href="a00006.html">Sensor</a> sensor)  throws SQLException </td></tr>
<tr class="memdesc:a132d764d3f79cd8c4245b6c91a4380cb"><td class="mdescLeft">&#160;</td><td class="mdescRight">Add a sensor and its Datatable.  <a href="#a132d764d3f79cd8c4245b6c91a4380cb"></a><br/></td></tr>
<tr class="separator:a132d764d3f79cd8c4245b6c91a4380cb"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0d59441cabc1dfe056c5533351d23bd7"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a0d59441cabc1dfe056c5533351d23bd7">getSensor</a> (String name)  throws SQLException </td></tr>
<tr class="memdesc:a0d59441cabc1dfe056c5533351d23bd7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Get a specific sensor based on its name.  <a href="#a0d59441cabc1dfe056c5533351d23bd7"></a><br/></td></tr>
<tr class="separator:a0d59441cabc1dfe056c5533351d23bd7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9510a442af2f6c479bdff029f4a06859"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a9510a442af2f6c479bdff029f4a06859">getSensorNr</a> (String name)  throws SQLException </td></tr>
<tr class="memdesc:a9510a442af2f6c479bdff029f4a06859"><td class="mdescLeft">&#160;</td><td class="mdescRight">Get a specific sensor nr.  <a href="#a9510a442af2f6c479bdff029f4a06859"></a><br/></td></tr>
<tr class="separator:a9510a442af2f6c479bdff029f4a06859"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae355f406a70b4a812812da846948f4fe"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#ae355f406a70b4a812812da846948f4fe">getAllSensors</a> ()  throws SQLException </td></tr>
<tr class="memdesc:ae355f406a70b4a812812da846948f4fe"><td class="mdescLeft">&#160;</td><td class="mdescRight">Get all sensors.  <a href="#ae355f406a70b4a812812da846948f4fe"></a><br/></td></tr>
<tr class="separator:ae355f406a70b4a812812da846948f4fe"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a14ba74caccde5492a3c11a2a321600f2"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a14ba74caccde5492a3c11a2a321600f2">getSensorDataTypes</a> (int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:a14ba74caccde5492a3c11a2a321600f2"><td class="mdescLeft">&#160;</td><td class="mdescRight">Gets the data columns of a Sensor.  <a href="#a14ba74caccde5492a3c11a2a321600f2"></a><br/></td></tr>
<tr class="separator:a14ba74caccde5492a3c11a2a321600f2"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8bd3a8829c96ebe691b63be43291159b"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a8bd3a8829c96ebe691b63be43291159b">getSensorData</a> (int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:a8bd3a8829c96ebe691b63be43291159b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns all the data of a specific sensor.  <a href="#a8bd3a8829c96ebe691b63be43291159b"></a><br/></td></tr>
<tr class="separator:a8bd3a8829c96ebe691b63be43291159b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:afe0fa27278448052d4255fc9b3ecb3c4"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#afe0fa27278448052d4255fc9b3ecb3c4">getSpecificSensorData</a> (long minimum, long maximum, int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:afe0fa27278448052d4255fc9b3ecb3c4"><td class="mdescLeft">&#160;</td><td class="mdescRight">Get specific data of a sensor between two Timestamp's.  <a href="#afe0fa27278448052d4255fc9b3ecb3c4"></a><br/></td></tr>
<tr class="separator:afe0fa27278448052d4255fc9b3ecb3c4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:acd55af2a210d1f28920f42558a75c3cf"><td class="memItemLeft" align="right" valign="top">String&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf">getDataTableName</a> (int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:acd55af2a210d1f28920f42558a75c3cf"><td class="mdescLeft">&#160;</td><td class="mdescRight">Get the datatable name.  <a href="#acd55af2a210d1f28920f42558a75c3cf"></a><br/></td></tr>
<tr class="separator:acd55af2a210d1f28920f42558a75c3cf"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1a35562bbd8691ac941c7e7936a89e7a"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a1a35562bbd8691ac941c7e7936a89e7a">removeSensorAndDataTable</a> (int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:a1a35562bbd8691ac941c7e7936a89e7a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Remove sensor and the Datatable.  <a href="#a1a35562bbd8691ac941c7e7936a89e7a"></a><br/></td></tr>
<tr class="separator:a1a35562bbd8691ac941c7e7936a89e7a"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pac-static-attribs"></a>
Static Package Attributes</h2></td></tr>
<tr class="memitem:aec4e6cc03ffb6c2ccad44e0bd6947af3"><td class="memItemLeft" align="right" valign="top">static Logger&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#aec4e6cc03ffb6c2ccad44e0bd6947af3">logger</a> = Logger.getLogger(DaoSensor.class.getName())</td></tr>
<tr class="separator:aec4e6cc03ffb6c2ccad44e0bd6947af3"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pri-methods"></a>
Private Member Functions</h2></td></tr>
<tr class="memitem:a8c906f891ffae536ae8b69f59d8db0c5"><td class="memItemLeft" align="right" valign="top">ResultSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a8c906f891ffae536ae8b69f59d8db0c5">addSensor</a> (<a class="el" href="a00006.html">Sensor</a> sensor)  throws SQLException </td></tr>
<tr class="memdesc:a8c906f891ffae536ae8b69f59d8db0c5"><td class="mdescLeft">&#160;</td><td class="mdescRight">Add an sensor object to the database, only used internally.  <a href="#a8c906f891ffae536ae8b69f59d8db0c5"></a><br/></td></tr>
<tr class="separator:a8c906f891ffae536ae8b69f59d8db0c5"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a583d90cb564c9c97d6fdf4d0e2566edd"><td class="memItemLeft" align="right" valign="top">String&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a583d90cb564c9c97d6fdf4d0e2566edd">addDataTable</a> (<a class="el" href="a00006.html">Sensor</a> sensor, int sensorNr)  throws SQLException </td></tr>
<tr class="memdesc:a583d90cb564c9c97d6fdf4d0e2566edd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Adds an datatable iterates through the DataStruc <a class="el" href="a00005.html">saxion.sensorframework.structuur.DataStruc</a> of the Sensor <a class="el" href="a00006.html">saxion.sensorframework.structuur.Sensor</a>.  <a href="#a583d90cb564c9c97d6fdf4d0e2566edd"></a><br/></td></tr>
<tr class="separator:a583d90cb564c9c97d6fdf4d0e2566edd"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8029440908b08166d920a9db0b282be0"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a8029440908b08166d920a9db0b282be0">updateDataTableInSensor</a> (int sensorNr, String dataTableName)  throws SQLException </td></tr>
<tr class="memdesc:a8029440908b08166d920a9db0b282be0"><td class="mdescLeft">&#160;</td><td class="mdescRight">Update the datatable field in the Sensor table.  <a href="#a8029440908b08166d920a9db0b282be0"></a><br/></td></tr>
<tr class="separator:a8029440908b08166d920a9db0b282be0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a55cbcc71d37d7c53a6666969ef6e8a93"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a55cbcc71d37d7c53a6666969ef6e8a93">removeSensor</a> (int sensornr)  throws SQLException </td></tr>
<tr class="memdesc:a55cbcc71d37d7c53a6666969ef6e8a93"><td class="mdescLeft">&#160;</td><td class="mdescRight">Remove sensor used internally.  <a href="#a55cbcc71d37d7c53a6666969ef6e8a93"></a><br/></td></tr>
<tr class="separator:a55cbcc71d37d7c53a6666969ef6e8a93"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa1919db0fd363899c4df1eaccd10d5bc"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#aa1919db0fd363899c4df1eaccd10d5bc">checkandAddSensorTable</a> ()  throws SQLException </td></tr>
<tr class="memdesc:aa1919db0fd363899c4df1eaccd10d5bc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Check and add the Sensor table if its not present in the database.  <a href="#aa1919db0fd363899c4df1eaccd10d5bc"></a><br/></td></tr>
<tr class="separator:aa1919db0fd363899c4df1eaccd10d5bc"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pri-attribs"></a>
Private Attributes</h2></td></tr>
<tr class="memitem:a53393b4353611f03c6c850efdd906156"><td class="memItemLeft" align="right" valign="top">SqlConnect&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00003.html#a53393b4353611f03c6c850efdd906156">conn</a></td></tr>
<tr class="memdesc:a53393b4353611f03c6c850efdd906156"><td class="mdescLeft">&#160;</td><td class="mdescRight">&lt; logger  <a href="#a53393b4353611f03c6c850efdd906156"></a><br/></td></tr>
<tr class="separator:a53393b4353611f03c6c850efdd906156"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><p>The Data Acces Object wich contains all data queries that will be executed by SqlConnect. </p>
<dl class="section author"><dt>Author</dt><dd>Erik &amp; Martijn </dd></dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00020">20</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>
</div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
<a class="anchor" id="ac88517169df3e3a6d6fbdda5abd781f1"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">saxion.sensorframework.db.dao.DaoSensor.DaoSensor </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td>  throws SQLException, InstantiationException, 			IllegalAccessException, ClassNotFoundException </td>
        </tr>
      </table>
</div><div class="memdoc">
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
    <tr><td class="paramname">InstantiationException</td><td></td></tr>
    <tr><td class="paramname">IllegalAccessException</td><td></td></tr>
    <tr><td class="paramname">ClassNotFoundException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00032">32</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_ac88517169df3e3a6d6fbdda5abd781f1_cgraph.png" border="0" usemap="#a00003_ac88517169df3e3a6d6fbdda5abd781f1_cgraph" alt=""/></div>
<map name="a00003_ac88517169df3e3a6d6fbdda5abd781f1_cgraph" id="a00003_ac88517169df3e3a6d6fbdda5abd781f1_cgraph">
<area shape="rect" href="a00003.html#aa1919db0fd363899c4df1eaccd10d5bc" title="Check and add the Sensor table if its not present in the database." alt="" coords="267,5,515,48"/></map>
</div>
</p>

</div>
</div>
<h2 class="groupheader">Member Function Documentation</h2>
<a class="anchor" id="a583d90cb564c9c97d6fdf4d0e2566edd"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">String saxion.sensorframework.db.dao.DaoSensor.addDataTable </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="a00006.html">Sensor</a>&#160;</td>
          <td class="paramname"><em>sensor</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td>  throws SQLException </td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Adds an datatable iterates through the DataStruc <a class="el" href="a00005.html">saxion.sensorframework.structuur.DataStruc</a> of the Sensor <a class="el" href="a00006.html">saxion.sensorframework.structuur.Sensor</a>. </p>
<p>This method will add an datatable to the database. It will get the DataStruc of the Sensor and it will construct a query wich will be written to the database. The following type's will be supported in this method with the corresponding database type: -Int &ndash; numeric(18) -String &ndash; varchar(30) -bool &ndash; Tinyint(1) -datetime &ndash; DATETIME</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensor</td><td></td></tr>
    <tr><td class="paramname">sensorNr</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Tablename </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00078">78</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_cgraph.png" border="0" usemap="#a00003_a583d90cb564c9c97d6fdf4d0e2566edd_cgraph" alt=""/></div>
<map name="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_cgraph" id="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_cgraph">
<area shape="rect" href="a00005.html#ac9148170ae0ada0c0344d3da069d00ec" title="Get the type of the DataStruc." alt="" coords="268,5,492,48"/><area shape="rect" href="a00005.html#ad33199a43d24fcacc9da03a6e7e96f20" title="Get the name of the DataStruc." alt="" coords="268,72,492,115"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_icgraph.png" border="0" usemap="#a00003_a583d90cb564c9c97d6fdf4d0e2566edd_icgraph" alt=""/></div>
<map name="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_icgraph" id="a00003_a583d90cb564c9c97d6fdf4d0e2566edd_icgraph">
<area shape="rect" href="a00003.html#a132d764d3f79cd8c4245b6c91a4380cb" title="Add a sensor and its Datatable." alt="" coords="268,272,508,315"/><area shape="rect" href="a00011.html#ad8754fda51b1d368982844746d4c7e3d" title="Register Sensor." alt="" coords="576,5,800,48"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="585,72,791,115"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="585,139,791,181"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="585,205,791,248"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="585,272,791,315"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="559,339,817,397"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="576,421,800,464"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="576,488,800,531"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="585,555,791,597"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a8c906f891ffae536ae8b69f59d8db0c5"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.addSensor </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="a00006.html">Sensor</a>&#160;</td>
          <td class="paramname"><em>sensor</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Add an sensor object to the database, only used internally. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensor</td><td>object </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>a Resultset with the generated keys </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00046">46</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a8c906f891ffae536ae8b69f59d8db0c5_icgraph.png" border="0" usemap="#a00003_a8c906f891ffae536ae8b69f59d8db0c5_icgraph" alt=""/></div>
<map name="a00003_a8c906f891ffae536ae8b69f59d8db0c5_icgraph" id="a00003_a8c906f891ffae536ae8b69f59d8db0c5_icgraph">
<area shape="rect" href="a00003.html#a132d764d3f79cd8c4245b6c91a4380cb" title="Add a sensor and its Datatable." alt="" coords="268,272,508,315"/><area shape="rect" href="a00011.html#ad8754fda51b1d368982844746d4c7e3d" title="Register Sensor." alt="" coords="576,5,800,48"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="585,72,791,115"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="585,139,791,181"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="585,205,791,248"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="585,272,791,315"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="559,339,817,397"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="576,421,800,464"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="576,488,800,531"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="585,555,791,597"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a132d764d3f79cd8c4245b6c91a4380cb"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int saxion.sensorframework.db.dao.DaoSensor.addSensorAndDataTable </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="a00006.html">Sensor</a>&#160;</td>
          <td class="paramname"><em>sensor</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Add a sensor and its Datatable. </p>
<p>Add a Sensor and a Datatable based on the DataStruc of the Sensor. This method will call method's in this class in the the following steps -addSensor Add the sensor to the database -getSensornr Get the generated Id -addDataTable Add a datatable to the database -updateDataTableInSensor Update the name of the datatable in the corresponding Sensor row</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensor</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Sensor nr </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00256">256</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a132d764d3f79cd8c4245b6c91a4380cb_cgraph.png" border="0" usemap="#a00003_a132d764d3f79cd8c4245b6c91a4380cb_cgraph" alt=""/></div>
<map name="a00003_a132d764d3f79cd8c4245b6c91a4380cb_cgraph" id="a00003_a132d764d3f79cd8c4245b6c91a4380cb_cgraph">
<area shape="rect" href="a00003.html#a8c906f891ffae536ae8b69f59d8db0c5" title="Add an sensor object to the database, only used internally." alt="" coords="313,5,527,48"/><area shape="rect" href="a00003.html#a9510a442af2f6c479bdff029f4a06859" title="Get a specific sensor nr." alt="" coords="313,72,527,115"/><area shape="rect" href="a00003.html#a583d90cb564c9c97d6fdf4d0e2566edd" title="Adds an datatable iterates through the DataStruc saxion.sensorframework.structuur.DataStruc of the Sensor saxion.sensorframework.structuur.Sensor." alt="" coords="313,139,527,181"/><area shape="rect" href="a00003.html#a8029440908b08166d920a9db0b282be0" title="Update the datatable field in the Sensor table." alt="" coords="297,205,543,248"/><area shape="rect" href="a00005.html#ac9148170ae0ada0c0344d3da069d00ec" title="Get the type of the DataStruc." alt="" coords="593,105,817,148"/><area shape="rect" href="a00005.html#ad33199a43d24fcacc9da03a6e7e96f20" title="Get the name of the DataStruc." alt="" coords="593,172,817,215"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a132d764d3f79cd8c4245b6c91a4380cb_icgraph.png" border="0" usemap="#a00003_a132d764d3f79cd8c4245b6c91a4380cb_icgraph" alt=""/></div>
<map name="a00003_a132d764d3f79cd8c4245b6c91a4380cb_icgraph" id="a00003_a132d764d3f79cd8c4245b6c91a4380cb_icgraph">
<area shape="rect" href="a00011.html#ad8754fda51b1d368982844746d4c7e3d" title="Register Sensor." alt="" coords="315,5,539,48"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="324,72,529,115"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="324,139,529,181"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="324,205,529,248"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="324,272,529,315"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="297,339,556,397"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="315,421,539,464"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="315,488,539,531"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="324,555,529,597"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a05fec2fa9ee7f94a099c7ddc2e9fe98a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void saxion.sensorframework.db.dao.DaoSensor.addSensorData </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">List&lt; Object &gt;&#160;</td>
          <td class="paramname"><em>list</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Add sensor data to the database. </p>
<p>Add Sensor data to the corresponding datatable of the sensor with the id given to this method. It will read the list wich contains the data and builds a query using a StringBuilder.</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
    <tr><td class="paramname">list</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00212">212</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_cgraph.png" border="0" usemap="#a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_cgraph" alt=""/></div>
<map name="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_cgraph" id="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_cgraph">
<area shape="rect" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf" title="Get the datatable name." alt="" coords="267,5,480,48"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_icgraph.png" border="0" usemap="#a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_icgraph" alt=""/></div>
<map name="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_icgraph" id="a00003_a05fec2fa9ee7f94a099c7ddc2e9fe98a_icgraph">
<area shape="rect" href="a00008.html#ae0715c7d7fd39f2802859cc66270df60" title="Reads xml data to database." alt="" coords="275,5,485,48"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="277,72,483,115"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="268,139,492,181"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="277,205,483,248"/><area shape="rect" href="a00011.html#ad85def6a26ecac56b8d1ca92dbcb8ed3" title="register sensordata" alt="" coords="543,5,780,48"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="aa1919db0fd363899c4df1eaccd10d5bc"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">void saxion.sensorframework.db.dao.DaoSensor.checkandAddSensorTable </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Check and add the Sensor table if its not present in the database. </p>
<p>Used to check if the Sensor table exists if not the query will add it to the database.</p>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00185">185</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_aa1919db0fd363899c4df1eaccd10d5bc_icgraph.png" border="0" usemap="#a00003_aa1919db0fd363899c4df1eaccd10d5bc_icgraph" alt=""/></div>
<map name="a00003_aa1919db0fd363899c4df1eaccd10d5bc_icgraph" id="a00003_aa1919db0fd363899c4df1eaccd10d5bc_icgraph">
<area shape="rect" href="a00003.html#ac88517169df3e3a6d6fbdda5abd781f1" title="saxion.sensorframework.db.dao.\lDaoSensor.DaoSensor" alt="" coords="301,5,515,48"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ae355f406a70b4a812812da846948f4fe"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.getAllSensors </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Get all sensors. </p>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00308">308</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_ae355f406a70b4a812812da846948f4fe_icgraph.png" border="0" usemap="#a00003_ae355f406a70b4a812812da846948f4fe_icgraph" alt=""/></div>
<map name="a00003_ae355f406a70b4a812812da846948f4fe_icgraph" id="a00003_ae355f406a70b4a812812da846948f4fe_icgraph">
<area shape="rect" href="a00001.html#a982c196b63114ded06436a390e25ea42" title="Get sensors from database." alt="" coords="269,5,472,48"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="268,72,473,115"/><area shape="rect" href="a00002.html#aee8d0ff49c8e16a75ac229c938aa3151" title="Get sensors from database." alt="" coords="523,5,739,48"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="acd55af2a210d1f28920f42558a75c3cf"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">String saxion.sensorframework.db.dao.DaoSensor.getDataTableName </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Get the datatable name. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>String met de desbetreffende </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00396">396</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_acd55af2a210d1f28920f42558a75c3cf_icgraph.png" border="0" usemap="#a00003_acd55af2a210d1f28920f42558a75c3cf_icgraph" alt=""/></div>
<map name="a00003_acd55af2a210d1f28920f42558a75c3cf_icgraph" id="a00003_acd55af2a210d1f28920f42558a75c3cf_icgraph">
<area shape="rect" href="a00003.html#a05fec2fa9ee7f94a099c7ddc2e9fe98a" title="Add sensor data to the database." alt="" coords="292,372,505,415"/><area shape="rect" href="a00003.html#a14ba74caccde5492a3c11a2a321600f2" title="Gets the data columns of a Sensor." alt="" coords="291,205,507,248"/><area shape="rect" href="a00003.html#a8bd3a8829c96ebe691b63be43291159b" title="Returns all the data of a specific sensor." alt="" coords="292,305,505,348"/><area shape="rect" href="a00003.html#afe0fa27278448052d4255fc9b3ecb3c4" title="Get specific data of a sensor between two Timestamp&#39;s." alt="" coords="285,439,512,481"/><area shape="rect" href="a00003.html#a1a35562bbd8691ac941c7e7936a89e7a" title="Remove sensor and the Datatable." alt="" coords="267,505,531,548"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="607,788,812,831"/><area shape="rect" href="a00008.html#ae0715c7d7fd39f2802859cc66270df60" title="Reads xml data to database." alt="" coords="604,172,815,215"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="607,305,812,348"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="597,439,821,481"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="607,372,812,415"/><area shape="rect" href="a00011.html#ad85def6a26ecac56b8d1ca92dbcb8ed3" title="register sensordata" alt="" coords="903,205,1140,248"/><area shape="rect" href="a00001.html#a5e7560ea630691d98a01f38633f2cd6b" title="Get sensor data fields from database." alt="" coords="605,5,813,48"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="597,239,821,281"/><area shape="rect" href="a00002.html#a56ec40ffab46ffed973864b8cf27cf66" title="get the sensor datafield" alt="" coords="893,5,1149,48"/><area shape="rect" href="a00001.html#a9a37b5711a12331f0d81e19821af4c5a" title="Get sensor data." alt="" coords="608,105,811,148"/><area shape="rect" href="a00002.html#a0a3dd93a64a51a70684449caa7b7fdfb" title="get sensor data." alt="" coords="912,72,1131,115"/><area shape="rect" href="a00002.html#af1792c53e335aeeac935bac5dd89cf63" title="get sensor data." alt="" coords="888,139,1155,181"/><area shape="rect" href="a00001.html#a21ff593b140baa80d3c512922ffb5ffe" title="Get sensor data." alt="" coords="608,505,811,548"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="607,572,812,615"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="607,639,812,681"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="580,705,839,764"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a0d59441cabc1dfe056c5533351d23bd7"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.getSensor </td>
          <td>(</td>
          <td class="paramtype">String&#160;</td>
          <td class="paramname"><em>name</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Get a specific sensor based on its name. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">name</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00272">272</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a0d59441cabc1dfe056c5533351d23bd7_icgraph.png" border="0" usemap="#a00003_a0d59441cabc1dfe056c5533351d23bd7_icgraph" alt=""/></div>
<map name="a00003_a0d59441cabc1dfe056c5533351d23bd7_icgraph" id="a00003_a0d59441cabc1dfe056c5533351d23bd7_icgraph">
<area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="268,5,473,48"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="268,72,473,115"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a8bd3a8829c96ebe691b63be43291159b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.getSensorData </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Returns all the data of a specific sensor. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Resultset with all the data </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00345">345</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a8bd3a8829c96ebe691b63be43291159b_cgraph.png" border="0" usemap="#a00003_a8bd3a8829c96ebe691b63be43291159b_cgraph" alt=""/></div>
<map name="a00003_a8bd3a8829c96ebe691b63be43291159b_cgraph" id="a00003_a8bd3a8829c96ebe691b63be43291159b_cgraph">
<area shape="rect" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf" title="Get the datatable name." alt="" coords="267,5,480,48"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a8bd3a8829c96ebe691b63be43291159b_icgraph.png" border="0" usemap="#a00003_a8bd3a8829c96ebe691b63be43291159b_icgraph" alt=""/></div>
<map name="a00003_a8bd3a8829c96ebe691b63be43291159b_icgraph" id="a00003_a8bd3a8829c96ebe691b63be43291159b_icgraph">
<area shape="rect" href="a00001.html#a9a37b5711a12331f0d81e19821af4c5a" title="Get sensor data." alt="" coords="269,39,472,81"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="268,105,473,148"/><area shape="rect" href="a00002.html#a0a3dd93a64a51a70684449caa7b7fdfb" title="get sensor data." alt="" coords="547,5,765,48"/><area shape="rect" href="a00002.html#af1792c53e335aeeac935bac5dd89cf63" title="get sensor data." alt="" coords="523,72,789,115"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a14ba74caccde5492a3c11a2a321600f2"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.getSensorDataTypes </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Gets the data columns of a Sensor. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>ResultSet with the Columns </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00325">325</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a14ba74caccde5492a3c11a2a321600f2_cgraph.png" border="0" usemap="#a00003_a14ba74caccde5492a3c11a2a321600f2_cgraph" alt=""/></div>
<map name="a00003_a14ba74caccde5492a3c11a2a321600f2_cgraph" id="a00003_a14ba74caccde5492a3c11a2a321600f2_cgraph">
<area shape="rect" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf" title="Get the datatable name." alt="" coords="272,5,485,48"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a14ba74caccde5492a3c11a2a321600f2_icgraph.png" border="0" usemap="#a00003_a14ba74caccde5492a3c11a2a321600f2_icgraph" alt=""/></div>
<map name="a00003_a14ba74caccde5492a3c11a2a321600f2_icgraph" id="a00003_a14ba74caccde5492a3c11a2a321600f2_icgraph">
<area shape="rect" href="a00001.html#a5e7560ea630691d98a01f38633f2cd6b" title="Get sensor data fields from database." alt="" coords="281,5,489,48"/><area shape="rect" href="a00008.html#ae0715c7d7fd39f2802859cc66270df60" title="Reads xml data to database." alt="" coords="280,72,491,115"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="273,139,497,181"/><area shape="rect" href="a00002.html#a56ec40ffab46ffed973864b8cf27cf66" title="get the sensor datafield" alt="" coords="547,5,803,48"/><area shape="rect" href="a00011.html#ad85def6a26ecac56b8d1ca92dbcb8ed3" title="register sensordata" alt="" coords="556,72,793,115"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a9510a442af2f6c479bdff029f4a06859"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int saxion.sensorframework.db.dao.DaoSensor.getSensorNr </td>
          <td>(</td>
          <td class="paramtype">String&#160;</td>
          <td class="paramname"><em>name</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Get a specific sensor nr. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">name</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00289">289</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a9510a442af2f6c479bdff029f4a06859_icgraph.png" border="0" usemap="#a00003_a9510a442af2f6c479bdff029f4a06859_icgraph" alt=""/></div>
<map name="a00003_a9510a442af2f6c479bdff029f4a06859_icgraph" id="a00003_a9510a442af2f6c479bdff029f4a06859_icgraph">
<area shape="rect" href="a00003.html#a132d764d3f79cd8c4245b6c91a4380cb" title="Add a sensor and its Datatable." alt="" coords="268,272,508,315"/><area shape="rect" href="a00011.html#ad8754fda51b1d368982844746d4c7e3d" title="Register Sensor." alt="" coords="576,5,800,48"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="585,72,791,115"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="585,139,791,181"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="585,205,791,248"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="585,272,791,315"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="559,339,817,397"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="576,421,800,464"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="576,488,800,531"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="585,555,791,597"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="afe0fa27278448052d4255fc9b3ecb3c4"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ResultSet saxion.sensorframework.db.dao.DaoSensor.getSpecificSensorData </td>
          <td>(</td>
          <td class="paramtype">long&#160;</td>
          <td class="paramname"><em>minimum</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">long&#160;</td>
          <td class="paramname"><em>maximum</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Get specific data of a sensor between two Timestamp's. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">minimum</td><td>Start data </td></tr>
    <tr><td class="paramname">maximum</td><td>End data </td></tr>
    <tr><td class="paramname">sensorNr</td><td>The sensor nr </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A ResultSet with the data </dd></dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00369">369</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_afe0fa27278448052d4255fc9b3ecb3c4_cgraph.png" border="0" usemap="#a00003_afe0fa27278448052d4255fc9b3ecb3c4_cgraph" alt=""/></div>
<map name="a00003_afe0fa27278448052d4255fc9b3ecb3c4_cgraph" id="a00003_afe0fa27278448052d4255fc9b3ecb3c4_cgraph">
<area shape="rect" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf" title="Get the datatable name." alt="" coords="280,5,493,48"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_afe0fa27278448052d4255fc9b3ecb3c4_icgraph.png" border="0" usemap="#a00003_afe0fa27278448052d4255fc9b3ecb3c4_icgraph" alt=""/></div>
<map name="a00003_afe0fa27278448052d4255fc9b3ecb3c4_icgraph" id="a00003_afe0fa27278448052d4255fc9b3ecb3c4_icgraph">
<area shape="rect" href="a00001.html#a21ff593b140baa80d3c512922ffb5ffe" title="Get sensor data." alt="" coords="292,5,495,48"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="281,72,505,115"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a55cbcc71d37d7c53a6666969ef6e8a93"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">void saxion.sensorframework.db.dao.DaoSensor.removeSensor </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensornr</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Remove sensor used internally. </p>
<p>Can be used to delete a sensor from the database it will not remove the Datatable.</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensornr</td><td>The nr used to delete the sensor </td></tr>
  </table>
  </dd>
</dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00167">167</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a55cbcc71d37d7c53a6666969ef6e8a93_icgraph.png" border="0" usemap="#a00003_a55cbcc71d37d7c53a6666969ef6e8a93_icgraph" alt=""/></div>
<map name="a00003_a55cbcc71d37d7c53a6666969ef6e8a93_icgraph" id="a00003_a55cbcc71d37d7c53a6666969ef6e8a93_icgraph">
<area shape="rect" href="a00003.html#a1a35562bbd8691ac941c7e7936a89e7a" title="Remove sensor and the Datatable." alt="" coords="267,243,531,285"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="607,5,812,48"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="607,72,812,115"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="607,139,812,181"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="607,205,812,248"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="580,272,839,331"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="597,355,821,397"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="597,421,821,464"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="607,488,812,531"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a1a35562bbd8691ac941c7e7936a89e7a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void saxion.sensorframework.db.dao.DaoSensor.removeSensorAndDataTable </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em></td><td>)</td>
          <td>  throws SQLException </td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Remove sensor and the Datatable. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00415">415</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a1a35562bbd8691ac941c7e7936a89e7a_cgraph.png" border="0" usemap="#a00003_a1a35562bbd8691ac941c7e7936a89e7a_cgraph" alt=""/></div>
<map name="a00003_a1a35562bbd8691ac941c7e7936a89e7a_cgraph" id="a00003_a1a35562bbd8691ac941c7e7936a89e7a_cgraph">
<area shape="rect" href="a00003.html#acd55af2a210d1f28920f42558a75c3cf" title="Get the datatable name." alt="" coords="317,5,531,48"/><area shape="rect" href="a00003.html#a55cbcc71d37d7c53a6666969ef6e8a93" title="Remove sensor used internally." alt="" coords="317,72,531,115"/></map>
</div>
</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a1a35562bbd8691ac941c7e7936a89e7a_icgraph.png" border="0" usemap="#a00003_a1a35562bbd8691ac941c7e7936a89e7a_icgraph" alt=""/></div>
<map name="a00003_a1a35562bbd8691ac941c7e7936a89e7a_icgraph" id="a00003_a1a35562bbd8691ac941c7e7936a89e7a_icgraph">
<area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="345,5,551,48"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="345,72,551,115"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="345,139,551,181"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="345,205,551,248"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="319,272,577,331"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="336,355,560,397"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="336,421,560,464"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="345,488,551,531"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a8029440908b08166d920a9db0b282be0"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">void saxion.sensorframework.db.dao.DaoSensor.updateDataTableInSensor </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sensorNr</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">String&#160;</td>
          <td class="paramname"><em>dataTableName</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td>  throws SQLException </td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Update the datatable field in the Sensor table. </p>
<p>Update the datatable field in the Sensor table. The SensorId is used to get the right sensor and right dataTablename is also used. This method will be used after the datatable en sensor are added to the database.</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">sensorNr</td><td></td></tr>
    <tr><td class="paramname">dataTableName</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="exception"><dt>Exceptions</dt><dd>
  <table class="exception">
    <tr><td class="paramname">SQLException</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00147">147</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

<p><div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="a00003_a8029440908b08166d920a9db0b282be0_icgraph.png" border="0" usemap="#a00003_a8029440908b08166d920a9db0b282be0_icgraph" alt=""/></div>
<map name="a00003_a8029440908b08166d920a9db0b282be0_icgraph" id="a00003_a8029440908b08166d920a9db0b282be0_icgraph">
<area shape="rect" href="a00003.html#a132d764d3f79cd8c4245b6c91a4380cb" title="Add a sensor and its Datatable." alt="" coords="303,272,543,315"/><area shape="rect" href="a00011.html#ad8754fda51b1d368982844746d4c7e3d" title="Register Sensor." alt="" coords="611,5,835,48"/><area shape="rect" href="a00004.html#a120913a7423ededbd54189e186405df6" title="saxion.test.DaoSensorTest.test\lAddSensor" alt="" coords="620,72,825,115"/><area shape="rect" href="a00004.html#a08d7449394215d67314599de961a97c5" title="saxion.test.DaoSensorTest.test\lAddSensorData" alt="" coords="620,139,825,181"/><area shape="rect" href="a00004.html#a7f5426b3b11167a0fc278d03c44cbc4d" title="saxion.test.DaoSensorTest.test\lGetSensor" alt="" coords="620,205,825,248"/><area shape="rect" href="a00004.html#ab8e9cb6c63eef131dec95351e17c37f0" title="saxion.test.DaoSensorTest.test\lGetAllSensors" alt="" coords="620,272,825,315"/><area shape="rect" href="a00004.html#aa6f9b7a39e8152c076282c784e723599" title="saxion.test.DaoSensorTest.test\lAddSensorAndDataTableAndGetSensor\lAndRemoveSensoAndDataTable" alt="" coords="593,339,852,397"/><area shape="rect" href="a00004.html#af08235882eb1ae63b6d49a3fef2baca0" title="saxion.test.DaoSensorTest.testget\lSensorDataTypes" alt="" coords="611,421,835,464"/><area shape="rect" href="a00004.html#a94103739214ce5a04bceaf9d8b3a8c49" title="saxion.test.DaoSensorTest.testget\lSpecificSensorData" alt="" coords="611,488,835,531"/><area shape="rect" href="a00004.html#aca1c00798eb3dbf2c729e1b971945649" title="saxion.test.DaoSensorTest.test\lAddSensorsandData" alt="" coords="620,555,825,597"/></map>
</div>
</p>

</div>
</div>
<h2 class="groupheader">Member Data Documentation</h2>
<a class="anchor" id="a53393b4353611f03c6c850efdd906156"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">SqlConnect saxion.sensorframework.db.dao.DaoSensor.conn</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>&lt; logger </p>
<dl class="section see"><dt>See Also</dt><dd><a class="el" href="a00007.html#a42d5b539b22c0fca51cc3a1842d83e03" title="log4j used for logging.">SensorFramework::logger</a> </dd></dl>

<p>Definition at line <a class="el" href="a00018_source.html#l00023">23</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

</div>
</div>
<a class="anchor" id="aec4e6cc03ffb6c2ccad44e0bd6947af3"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">Logger saxion.sensorframework.db.dao.DaoSensor.logger = Logger.getLogger(DaoSensor.class.getName())</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">static</span><span class="mlabel">package</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="a00018_source.html#l00021">21</a> of file <a class="el" href="a00018_source.html">DaoSensor.java</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li>src/saxion/sensorframework/db/dao/<a class="el" href="a00018_source.html">DaoSensor.java</a></li>
</ul>
</div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated on Fri Feb 1 2013 11:25:02 for SensorFramework by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.2-20121118
</small></address>
</body>
</html>
